package com.commerceerp.system.mapper;

import com.commerceerp.system.entity.OrderFinishRecord;
import org.apache.ibatis.annotations.Param;

import java.math.BigDecimal;
import java.util.List;
import java.util.Map;

public interface OFRecordMapper {

    List<Map> getAllOFRecord(@Param("goodSystemSku")String goodSystemSku,@Param("beginTime")String beginTime,@Param("endTime")String endTime);

    List<Map> getProfitByDateGroup(@Param("goodSystemSku")String goodSystemSku,@Param("beginTime")String beginTime,@Param("endTime")String endTime);

    List<Map> getOrderMoneyByDateGroup(@Param("goodSystemSku")String goodSystemSku,@Param("beginTime")String beginTime,@Param("endTime")String endTime);

    List<Map> getOrderNumberByDateGroup(@Param("goodSystemSku")String goodSystemSku,@Param("beginTime")String beginTime,@Param("endTime")String endTime);

    List<Map> getAllFORecordSkuRate(@Param("goodSystemSku")String goodSystemSku,@Param("beginTime")String beginTime,@Param("endTime")String endTime);

    List<Map> getSkuOFNumber(@Param("goodSystemSku")String goodSystemSku,@Param("beginTime")String beginTime,@Param("endTime")String endTime);

    List<Map> getOFRGoodPriceCollect(@Param("goodSystemSku")String goodSystemSku,@Param("beginTime")String beginTime,@Param("endTime")String endTime);

    List<Map> getOFRGoodPriceDetail(@Param("goodSystemSku")String goodSystemSku, @Param("beginTime")String beginTime, @Param("endTime")String endTime, @Param("goodPrice")String goodPrice);

    List<Map> getOFRPriceRate(@Param("goodSystemSku")String goodSystemSku, @Param("beginTime")String beginTime, @Param("endTime")String endTime);

    List<Map> getUserDistribution(@Param("goodSystemSku")String goodSystemSku, @Param("beginTime")String beginTime, @Param("endTime")String endTime);

    List<Map> getUserDistributionRate(@Param("count") Integer count,@Param("goodSystemSku")String goodSystemSku, @Param("beginTime")String beginTime, @Param("endTime")String endTime);

    Integer saveNewOFRecord(OrderFinishRecord orderFinishRecord);

    //获得订单总数
    int getAllOrderNum();

    //获取商品信息
    Map getGoodInfo(@Param("orderSku") String order_sku);
}
